package com.qst.mapper;

import com.qst.entity.TestPersonnel;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TestPersonnelMapper {

    TestPersonnel findById(int id);

    List<TestPersonnel> findByTeam(int tid);

    List<TestPersonnel> query(@Param("teamId") int teamId, @Param("name") String name, @Param("stdNo") String stdNo);

    void insert(TestPersonnel s);

    @Delete("DELETE FROM testpersonnel WHERE id = #{id}")
    void delete(int id);

    void update(TestPersonnel s);

    TestPersonnel findByPhone(String phone);
}
